RetailValuationLedgerAccountHistory

Entity Definition

Logical Name : RetailValuationLedgerAccountHistory
Physical Name : LE_HST_STKACT_RTL

The RetailValuation portion of the StockLedgerAccount figures.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ReportingPeriodID (FK)(PK) The unique system assigned identifier for a particular ReportingPeriod. ID_PRD_RP Identity integer ReportingPeriod(CA_PRD_RP)
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer RetailValuationLedgerAccount(LE_STKACT_RTL)
RevenueCostCenterID (FK)(PK) A unique retailer assigned identifier for an accounting budget, that owns merchandise and is used to track the financial performance of the retail enterprise. ID_CTR_RVN_CST Identity integer RetailValuationLedgerAccount(LE_STKACT_RTL)
BeginningValueAmount The monetary value of all Items owned by the MerchandisingCenter at the beginning of the historical ReportingPeriod MO_VL_BGN Money decimal(16,5)
BeginningCumulativeMarkonAmount The markon amount (initial markon) at the beginning of the historical ReportingPeriod. MO_MKN_CM Money decimal(16,5)
BeginningCumulativeMarkonPercent The markon percentage (initial markon) at the beginning of the historical ReportingPeriod. PE_MKN_CM Percent decimal(7,4)
CumulativeGrossSalesRetailAmount The cumulative gross sales for a specific ITEM since the beginning of the historical ReportingPeriod. The gross figure excludes returns. TP_SLS_GS_CM Money decimal(16,5)
CumulativeReturnRetailAmount The cumulative retail value of merchandise that is returned by customers to the RetailStore during the historical ReportingPeriod. TP_RTN Money decimal(16,5)
CumulativeReceivedRetailAmount The cumulative retail value of units received for a particular ITEM since the beginning of the historical ReportingPeriod. TP_RCV Money decimal(16,5)
CumulativeTransferInRetailAmount The cumulative retail value of merchandise transferred into the store from other stores or distribution centers during the historical ReportingPeriod. MO_TSF_IN_CM Money decimal(16,5)
CumulativeTransferOutRetailAmount The cumulative retail value of merchandise transferred from the store to another store or distribution center during the historical ReportingPeriod. MO_TSF_OT_CM Money decimal(16,5)
CumulativeReturnToVendorRetailAmount The cumulative retail value of merchandise returned to the vendor from the store during the historical ReportingPeriod. TP_RTN_TO_VN Money decimal(16,5)
CumulativeAdjustmentRetailAmount The cumulative retail value of inventory adjustments (overages and shortages) made to ItemInventory during the historical ReportingPeriod. MO_ADJT_RT_CM Money decimal(16,5)
CumulativePermanentMarkdownAmount The cumulative value of permanent markdowns taken against this item during the historical ReportingPeriod. MO_MKD_PRN_CM Money decimal(16,5)
CumulativeTemporaryMarkdownAmount The cumulative temporary or promotional markdown value taken against this item either as a price change or through the application of price derivation rules at the point of sale during the historical ReportingPeriod. MO_MKD_TMP_CM Money decimal(16,5)
CumulativePermanentMarkupAmount The cumulative value of permanent markups taken against this item during the historical ReportingPeriod. MO_MKP_PRN_CM Money decimal(16,5)
CumulativeTemporaryMarkupAmount The cumulative temporary or promotional markup value taken against this item either as a price change or through the application of price derivation rules at the point of sale, during the historical ReportingPeriod. MO_MKP_TMP_CM Money decimal(16,5)
CumulativeDiscountAmount Cumulative value of all discounts granted for the item during the historical ReportingPeriod. MO_DSC_EM_CM Money decimal(16,5)
CumulativeDamagedItemDepreciationAmount Cumulative retail value lost due to damage to stock during the historical ReportingPeriod. MO_DPC_DM_CM_ITM Money decimal(16,5)
CumulativeOutOfDateItemDepreciationAmount Cumulative retail value lost due to stock aging past its sell-by date during the historical ReportingPeriod. MO_DPC_OT_OF_DT Money decimal(16,5)
EndingValueAmount The monetary value of all Items owned by the MerchandisingCenter at the end of the historical ReportingPeriod. MO_VL_END Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
ReportingPeriod delineates RetailValuationLedgerAccountHistory
RetailValuationLedgerAccount is tracked by RetailValuationLedgerAccountHistory

Logical Views containing RetailValuationLedgerAccountHistory

Logical View
Logical 02000 - Item Inventory and Stock Ledger View
Logical 03300 - Reporting - Stock Ledger View